SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_UpdateSurveyItem]

	(
	@param_id INT,
	@param_question NVARCHAR(200),
	@param_type BIT,
	@param_option1 NVARCHAR(100),
	@param_option2 NVARCHAR(100),
	@param_option3 NVARCHAR(100),
	@param_option4 NVARCHAR(100),
	@param_option5 NVARCHAR(100),
	@param_option6 NVARCHAR(100),
	@param_update_time SMALLDATETIME,
	@param_user_update NVARCHAR(50)
	)

AS
	/* SET NOCOUNT ON */
	UPDATE dbo.JOL_SurveyManagement_Items
	SET
	question=@param_question,
	type=@param_type,
	option1=@param_option1,
	option2=@param_option2,
	option3=@param_option3,
	option4=@param_option4,
	option5=@param_option5,
	option6=@param_option6,
	update_time=@param_update_time,
	user_update=@param_user_update
	WHERE id=@param_id
	RETURN
GO
